Model Videos

Video tutorials covering Model topics for Pro users. You can also download sample data that supports the use of those videos from this page.

Model Pro Overview

A walk-through demo on how to use the data preparation and modeling tools.

Model Lite Overview

An overview of the Model Lite interface for non-technical building of ETLs and data models.

Smart Model

Use Smart Model to build AI-driven databases.

Connect to Microsoft OLAP or Tabular

A quick demo on how to connect to Microsoft Analysis Services (OLAP or Tabular).

Connect to a SQL Database

A quick demo on connecting to and querying an existing relational database.

Direct Connect

Learn how to create a direct model to add a quick data model to an existing database.

Data Model Structures

An explanation of Data Models and Data Security.

Regular Hierarchies

Build SQL-based regular hierarchies in Model and navigate them in Discover.

Parent-Child Hierarchies

Build SQL-based Parent-child hierarchies in Model and navigate them in Discover.

Custom Maps

Create custom maps, based on your own custom shapes.

Data Statistics and Quality

Review statistics for the columns in a given table and take suggested actions, like adding time intelligence.

Python Data and Stock Charts

Learn how to download stock data in Model and use it to build charts in Discover.

Calculated Columns in Data Flows

Create or manipulate column values, or perform calculations on existing column values.

Virtual Column Aggregation

Extend an original data model with new row-level column calculations that will be appended as new attributes or measures to an existing model.

Unpivot Tool

Use the Unpivot tool to tabularize cross-tabbed data sets so they can be used in the analytics engine properly.

Extract SAP data with Glue

Use Datavard's Glue integration with Pyramid to extract raw SAP ERP data.

Buiding MS Tabular Models

Use Pyramid to design and build a Microsoft Tabular Model. Then use the model in Discover and Formulate.

Buiding Exasol Models

Use Pyramid to design and build an Exasol database and analytical model. Then use the model in Discover and Formulate.

Data Security

Learn how to set Data and Model security.

Master Flows

Use Master Flows to perform complex data cleansing and manipulation in multiple data flows.

Machine Learning

Review how machine learning is used internally in Pyramid and how users can perform machine learning in Pyramid.

Tabular Relationship Editor

Review how the relationship editor improves understanding of relationships in complex models with many tables.

Text Aggregations

How to consolidate multiple text-based attributes into a single cell.

Aggregate Tables

Define “short-cut” aggregate tables of attributes and measures to be used in queries, rather than the formal tables in the “master” semantic model.

Shared Tools

These videos cover tools that work in multiple apps in the application.

Personalized Data Catalogs

See how to customize data models (and associated data catalogs) both as a user and as an admin.

Data Model Validator

Use the validator to ensure that the semantic model in Pyramid is aligned with the target database.

Sample Data

Some of the videos use sample Excel data sets. You can download them here for your own testing: